AchBatchFileCompanyDetail

EntityType | Independent
Logical Entity Name | AchBatchFileCompanyDetail
Default Table Name | SaACHBatchCompanyDetail
Logical Only | NO
Owner | dbo
Definition |
Note |

AchBatchFileCompanyDetail Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
AchBatchFileCompanyDetailId |  | INTEGER | NO |
AchBatchFileCompanyHeaderId |  | INTEGER | NO |
StudentAccountTransactionId |  | INTEGER | NO |
TransactionCode |  | CHAR(2) | NO |
RecordDfiIdentifier |  | CHAR(8) | NO |
DfiAccountNumber |  | VARCHAR(100) | YES |
Amount |  | MONEY(19, 4) | NO |
AccountName |  | VARCHAR(22) | NO |
ResponseCode |  | CHAR(3) | YES |
NOCCode |  | CHAR(3) | YES |
CorrectedData |  | VARCHAR(29) | YES |
HoldStudentGroupId |  | INTEGER | YES |
TaskId |  | INTEGER | YES |
ResponseStudentAccountTransactionId |  | INTEGER | YES |
NSFApplied |  | INTEGER | YES |
BillingTransactionCodeId |  | INTEGER | YES |
ChargeAmount |  | MONEY(19, 4) | YES |
ResponseDate |  | DATETIME | YES |
CorrectedDFIAccountNumber |  | VARCHAR(50) | YES |
CorrectedRoutingNumber |  | VARCHAR(50) | YES |
CorrectedTransactionCode |  | VARCHAR(50) | YES |
RowVersion |  | TIMESTAMP/DATE | NO |
ScheduledDisbursementId |  | INTEGER | YES |
RefundId |  | INTEGER | YES |
InitializationVector |  | VARCHAR(100) | YES |
StudentGroupId |  | INTEGER | YES |

AchBatchFileCompanyDetail Keys

Key Name | Key Type | Keys
SaACHBatchCompanyDetail_SaACHBatchCompanyID_N_N_IDX | Inversion Entry | AchBatchFileCompanyHeaderId
SaACHBatchCompanyDetail_SaACHBatchCompanyDetailID_U_C_IDX | PrimaryKey | AchBatchFileCompanyDetailId

AchBatchFileCompanyDetail Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
BillingTransactionCode | Non-Identifying | Zero or One to Zero or More |  |  |  | BillingTransactionCodeId | NO
StudentGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentGroupId | NO
Refund | Non-Identifying | Zero or One to Zero or More |  |  |  | RefundId | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  | StudentAccountTransactionId | NO
ScheduledDisbursement | Non-Identifying | Zero or One to Zero or More |  |  |  | ScheduledDisbursementId | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  | StudentAccountTransactionId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

AchBatchFileCompanyDetail Check Constraints

Check Constraint Name | CheckConstraint

AchBatchFileCompanyDetail Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.AchBatchFileCompanyDetail | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaACHBatchCompanyDetail | NO |  |  |

AchBatchFileCompanyDetail Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ElectronicPaymentProcessing
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

AchBatchFileCompanyDetail Data Movement Rules

Name | Type | Rule Text/Value